<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>NetApp Capacity - Orphaned by Performance</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Orphaned Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Orphaned Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Orphaned (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Orphaned DR Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton8" refQuery="Orphaned DR Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Overall Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Provisioned Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Provisioned</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Provisioned Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Subscribed %</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Overall Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Subscription %"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid silver"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>DR Provisioned</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="DR Capacity - Flexvols">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total DR Allocated (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid silver"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>DR Used</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton7" refQuery="DR Capacity - Flexvols">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total DR Used (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned vs Not Orphaned </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Volume Count)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_pieChart maxHotspots="10000" sliceStartAngle="90" refQuery="Orphaned Count" name="Combination Chart1">
																																<v2_pieTooltips/>
																																<v2_legend legendSuffixValues="last">
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																	<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="topRight"/>
																																	</v2_legendPosition></v2_legend>
																																<style>
																																	<CSS value="width:400px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_pieSlices borders="show" borderColor="white">
																																	<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Volume Count"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
																																<v2_defaultChartMeasure refDataItem="Volume Count"/></v2_pieChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned vs Not Orphaned </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Provisioned (TB))</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_pieChart maxHotspots="10000" sliceStartAngle="90" refQuery="Orphaned Capacity" name="Combination Chart2">
																																<v2_pieTooltips/>
																																<v2_legend legendSuffixValues="last">
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																	<v2_legendPosition>
									<v2_legendPreset legendPositionPreset="topRight"/>
								</v2_legendPosition></v2_legend>
																																<style>
																																	<CSS value="width:400px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_pieSlices borders="show" borderColor="white">
																																	<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Provisioned (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
																																<v2_defaultChartMeasure refDataItem="Provisioned (TB)"><style><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></v2_defaultChartMeasure></v2_pieChart>
					</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned Volumes</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(with &lt;= 5 IOPS by Size)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
					<v2_combinationChart maxHotspots="10000" name="Combination Chart20" refQuery="Orphaned by Capacity Range" depth="9">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					</v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar borderColor="white" barShape="box"><v2_solidPalette><v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="capacityRange"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange includeZeroForAutoScale="true" sameRangeAllInstances="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###,### Vols"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:400px;height:200px;color:#454545"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_defaultChartMeasure refDataItem="Volume Count"/><v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="topRight"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned Volumes</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Provisioned (GB) by Size)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
					<v2_combinationChart maxHotspots="10000" name="Combination Chart21" refQuery="Total Orphaned by Capacity Range" depth="9">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					</v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar borderColor="white" barShape="box"><v2_solidPalette><v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="capacityRange"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange includeZeroForAutoScale="true" sameRangeAllInstances="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###.##' GB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:400px;height:200px;color:#454545"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_defaultChartMeasure refDataItem="Provisioned (GB)"><style><dataFormat><numberFormat pattern="###,###.##' GB'"/></dataFormat></style></v2_defaultChartMeasure><v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="topRight"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned vs Orphaned DR</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Volume Count)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																														<v2_pieChart maxHotspots="10000" sliceStartAngle="90" refQuery="Orphaned vs Orphaned DR" name="Combination Chart3">
																																<v2_pieTooltips/>
																																<v2_legend legendSuffixValues="last">
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																	<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="topRight"/>
																																	</v2_legendPosition></v2_legend>
																																<style>
																																	<CSS value="width:400px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_pieSlices borders="show" borderColor="white">
																																	<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Volume Count"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
																																<v2_defaultChartMeasure refDataItem="Volume Count"/></v2_pieChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned vs Orphaned DR</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Provisioned (TB))</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_pieChart maxHotspots="10000" sliceStartAngle="90" refQuery="Orphaned vs Orphaned DR Capacity" name="Combination Chart7">
																																<v2_pieTooltips/>
																																<v2_legend legendSuffixValues="last">
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																	<v2_legendPosition>
									<v2_legendPreset legendPositionPreset="topRight"/>
								</v2_legendPosition></v2_legend>
																																<style>
																																	<CSS value="width:400px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_pieSlices borders="show" borderColor="white">
																																	<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Provisioned (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
																																<v2_defaultChartMeasure refDataItem="Provisioned (TB)"><style><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></v2_defaultChartMeasure></v2_pieChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned Volumes</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Top 5 Clusters Vol Count)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart9" refQuery="Top 5 Clusters by Orphaned Count" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels>
																																		</v2_ordinalAxis>
																																</v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar setOrdinalWidthScale="50" borderColor="white" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Cluster"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="rank" sortOrder="descending"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange scale="log">
																																			<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###,### Vols"/></dataFormat></style>
																																		</v2_axisLabels>
																																		<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																																	</v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<defaultStyles>
																																		<defaultStyle refStyle="ch"/>
																																	</defaultStyles>
																																	<CSS value="width:400px;height:200px;color:#454545"/></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_defaultChartMeasure refDataItem="Volume Count"/><v2_legend>
																																	<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="topRight"/>
																																	</v2_legendPosition>
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																</v2_legend>
																																<XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned Volumes</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Top 5 Clusters Capacity)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart10" refQuery="Top 5 Clusters by Orphaned Capacity" depth="9">
							<v2_combinationTypeTooltips/>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
											<CSS value="color:#454545"/></style>
									</v2_axisLabels>
									</v2_ordinalAxis>
							</v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_bar setOrdinalWidthScale="50" borderColor="white" barShape="box">
										<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
										<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Cluster"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="rank" sortOrder="descending"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange scale="log">
										<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
									</v2_axisRange>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
											<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###.##' GB'"/></dataFormat></style>
									</v2_axisLabels>
									<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
								</v2_axis>
							</v2_topLeftAxis>
							<style>
								<defaultStyles>
									<defaultStyle refStyle="ch"/>
								</defaultStyles>
								<CSS value="width:400px;height:200px;color:#454545"/></style>
							<noDataHandler>
								<contents>
									<block>
										<contents>
											<textItem>
												<dataSource>
													<staticValue>No Data Available</staticValue>
												</dataSource>
												<style>
													<CSS value="padding:10px 18px;"/>
												</style>
											</textItem>
										</contents>
									</block>
								</contents>
							</noDataHandler>
							<v2_defaultChartMeasure refDataItem="Provisioned (GB)"><style><dataFormat><numberFormat pattern="###,###.##' GB'"/></dataFormat></style></v2_defaultChartMeasure><v2_legend>
								<v2_legendPosition>
									<v2_legendPreset legendPositionPreset="topRight"/>
								</v2_legendPosition>
								<style>
									<defaultStyles>
										<defaultStyle refStyle="lg"/>
									</defaultStyles>
								</style>
							</v2_legend>
							<XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned by Data Center</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Volume Count)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart5" refQuery="Orphaned Count by DC" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels>
																																		</v2_ordinalAxis>
																																</v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar setOrdinalWidthScale="50" borderColor="white" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="DataCenter"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Volume Count"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###,### Vols"/></dataFormat></style>
																																		</v2_axisLabels>
																																		<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																																	</v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<defaultStyles>
																																		<defaultStyle refStyle="ch"/>
																																	</defaultStyles>
																																	<CSS value="width:400px;height:200px;color:#454545"/></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_defaultChartMeasure refDataItem="Volume Count"/><v2_legend>
																																	<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="topRight"/>
																																	</v2_legendPosition>
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																</v2_legend>
																																<XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-right:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned by Data Center</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Provisioned (TB))</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart6" refQuery="Orphanced Capacity by DC" depth="9">
							<v2_combinationTypeTooltips/>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
											<CSS value="color:#454545"/></style>
									</v2_axisLabels>
									</v2_ordinalAxis>
							</v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_bar setOrdinalWidthScale="50" borderColor="white" barShape="box">
										<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
										<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="DataCenter"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Provisioned (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange scale="log">
										<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
									</v2_axisRange>
									<v2_axisLabels>
										<style>
											<defaultStyles>
												<defaultStyle refStyle="al"/>
											</defaultStyles>
											<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style>
									</v2_axisLabels>
									<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
								</v2_axis>
							</v2_topLeftAxis>
							<style>
								<defaultStyles>
									<defaultStyle refStyle="ch"/>
								</defaultStyles>
								<CSS value="width:400px;height:200px;color:#454545"/></style>
							<noDataHandler>
								<contents>
									<block>
										<contents>
											<textItem>
												<dataSource>
													<staticValue>No Data Available</staticValue>
												</dataSource>
												<style>
													<CSS value="padding:10px 18px;"/>
												</style>
											</textItem>
										</contents>
									</block>
								</contents>
							</noDataHandler>
							<v2_defaultChartMeasure refDataItem="Provisioned (TB)"><style><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></v2_defaultChartMeasure><v2_legend>
								<v2_legendPosition>
									<v2_legendPreset legendPositionPreset="topRight"/>
								</v2_legendPosition>
								<style>
									<defaultStyles>
										<defaultStyle refStyle="lg"/>
									</defaultStyles>
								</style>
							</v2_legend>
							<XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Large and Overprovisioned Volumes</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Volume Count)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart8" refQuery="Large Volumes" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels>
																																		</v2_ordinalAxis>
																																</v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar setOrdinalWidthScale="50" borderColor="white" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Volume Count"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###,### Vols"/></dataFormat></style>
																																		</v2_axisLabels>
																																		<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																																	</v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<defaultStyles>
																																		<defaultStyle refStyle="ch"/>
																																	</defaultStyles>
																																	<CSS value="width:400px;height:200px;color:#454545"/></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_defaultChartMeasure refDataItem="Volume Count"/><v2_legend>
																																	<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="topRight"/>
																																	</v2_legendPosition>
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																</v2_legend>
																																<XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Large and Thin Volumes</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Provisioned (GB))</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="Large Volumes" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels>
																																		</v2_ordinalAxis>
																																</v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar setOrdinalWidthScale="50" borderColor="white" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Allocated (GB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																																		</v2_axisLabels>
																																		<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																																	</v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<defaultStyles>
																																		<defaultStyle refStyle="ch"/>
																																	</defaultStyles>
																																	<CSS value="width:400px;height:200px;color:#454545"/></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_defaultChartMeasure refDataItem="Allocated (GB)"/><v2_legend>
																																	<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="topRight"/>
																																	</v2_legendPosition>
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="lg"/>
																																		</defaultStyles>
																																	</style>
																																</v2_legend>
																																<XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;height:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents/><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.15 NetApp Capacity - Orphaned by Performance</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Overall Capacity">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	
		
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalvolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)'
	
		
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL1].[Tier Name]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL1].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL1].[Provisioned (TB)]</expression></dataItem><dataItem name="Subscription %"><expression>[Provisioned (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="Free Capacity (TB)" aggregate="total"><expression>[Capacity (TB)]-[Used Capacity (TB)]</expression></dataItem></selection>
		</query><query name="DR Capacity - Flexvols">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_inventory.internal_volume.name as 'Source Volume Name',
dwh_inventory.storage.name as 'Source Storage Name',
dwh_inventory.storage.manufacturer as 'Source Manufacturer',
dwh_inventory.storage.model as 'Source Model',
dwh_inventory.storage.datacenter as 'Source Data Center',
dwh_inventory.dr_internal_volume_replica.technology as 'Source Type',
null as 'Source State',
dwh_inventory.internal_volume.lastSnapshotTime as 'Source State Time',

dwh_inventory.dr_internal_volume_replica.sourceInternalVolumeId as sourcevolid,
dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId as targetvolid,
dwh_inventory.internal_volume.snapshotAllocatedCapacityMB/1024 as 'Source Allocated GB',
dwh_inventory.internal_volume.snapshotUsedCapacityMB/1024 as 'Source Used GB',
target.targetvolume as 'Target Volume Name',
target.targetstorage as 'Target Storage Name',
target.targetmanufacturer as 'Target Manufacturer',
target.targetmodel as 'Target Model',
target.targettype as 'Target Type',
null as 'Target State',
target.targetstatetime as 'Target State Time',
target.targetdatacenter as 'Target Data Center',
target.snapallocatedGB as 'Target Allocated GB',
target.snapUsedGB as 'Target Used GB'


FROM dwh_inventory.internal_volume
JOIN dwh_inventory.storage
ON dwh_inventory.storage.id=dwh_inventory.internal_volume.storageid
JOIN dwh_inventory.dr_internal_volume_replica
ON dwh_inventory.dr_internal_volume_replica.sourceInternalVolumeId=dwh_inventory.internal_volume.id

JOIN

(SELECT
dwh_inventory.internal_volume.name as targetvolume,
dwh_inventory.storage.name as targetstorage,
dwh_inventory.storage.manufacturer as targetmanufacturer,
dwh_inventory.storage.datacenter as targetdatacenter,
dwh_inventory.storage.model as targetmodel,
dwh_inventory.internal_volume.lastSnapshotTime as targetstatetime,
dwh_inventory.dr_internal_volume_replica.technology as targettype,
dwh_inventory.dr_internal_volume_replica.sourceInternalVolumeId as sourcevolid,
dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId as targetvolid,
dwh_inventory.internal_volume.snapshotAllocatedCapacityMB/1024 as snapallocatedGB,
dwh_inventory.internal_volume.snapshotUsedCapacityMB/1024 as snapUsedGB

FROM dwh_inventory.internal_volume
JOIN dwh_inventory.storage
ON dwh_inventory.storage.id=dwh_inventory.internal_volume.storageid
JOIN dwh_inventory.dr_internal_volume_replica
ON dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId=dwh_inventory.internal_volume.id
) target ON target.targetvolid=dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Source Volume Name"/><mdProjectedItem name="Source Storage Name"/><mdProjectedItem name="Source Manufacturer"/><mdProjectedItem name="Source Model"/><mdProjectedItem name="Source Data Center"/><mdProjectedItem name="Source Type"/><mdProjectedItem name="Source State"/><mdProjectedItem name="Source State Time"/><mdProjectedItem name="sourcevolid"/><mdProjectedItem name="targetvolid"/><mdProjectedItem name="Source Allocated GB"/><mdProjectedItem name="Source Used GB"/><mdProjectedItem name="Target Volume Name"/><mdProjectedItem name="Target Storage Name"/><mdProjectedItem name="Target Manufacturer"/><mdProjectedItem name="Target Model"/><mdProjectedItem name="Target Type"/><mdProjectedItem name="Target State"/><mdProjectedItem name="Target State Time"/><mdProjectedItem name="Target Data Center"/><mdProjectedItem name="Target Allocated GB"/><mdProjectedItem name="Target Used GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Source Volume Name"><expression>[SQL2].[Source Volume Name]</expression></dataItem><dataItem name="Source Storage Name"><expression>[SQL2].[Source Storage Name]</expression></dataItem><dataItem name="Source Manufacturer"><expression>[SQL2].[Source Manufacturer]</expression></dataItem><dataItem name="Source Model"><expression>[SQL2].[Source Model]</expression></dataItem><dataItem name="Source Data Center"><expression>[SQL2].[Source Data Center]</expression></dataItem><dataItem name="Source Type"><expression>[SQL2].[Source Type]</expression></dataItem><dataItem name="Source State"><expression>[SQL2].[Source State]</expression></dataItem><dataItem name="Source State Time"><expression>[SQL2].[Source State Time]</expression></dataItem><dataItem name="sourcevolid"><expression>[SQL2].[sourcevolid]</expression></dataItem><dataItem name="targetvolid"><expression>[SQL2].[targetvolid]</expression></dataItem><dataItem name="Source Allocated GB" aggregate="total"><expression>[SQL2].[Source Allocated GB]/1024</expression></dataItem><dataItem name="Source Used GB" aggregate="total"><expression>[SQL2].[Source Used GB]/1024</expression></dataItem><dataItem name="Target Volume Name"><expression>[SQL2].[Target Volume Name]</expression></dataItem><dataItem name="Target Storage Name"><expression>[SQL2].[Target Storage Name]</expression></dataItem><dataItem name="Target Manufacturer"><expression>[SQL2].[Target Manufacturer]</expression></dataItem><dataItem name="Target Model"><expression>[SQL2].[Target Model]</expression></dataItem><dataItem name="Target Type"><expression>[SQL2].[Target Type]</expression></dataItem><dataItem name="Target State"><expression>[SQL2].[Target State]</expression></dataItem><dataItem name="Target State Time"><expression>[SQL2].[Target State Time]</expression></dataItem><dataItem name="Target Data Center"><expression>[SQL2].[Target Data Center]</expression></dataItem><dataItem name="Target Allocated GB" aggregate="total"><expression>[SQL2].[Target Allocated GB]</expression></dataItem><dataItem name="Target Used GB" aggregate="total"><expression>[SQL2].[Target Used GB]</expression></dataItem><dataItem name="Total DR Allocated (TB)" aggregate="total"><expression>[SQL2].[Source Allocated GB]/1024</expression></dataItem><dataItem name="Total DR Used (TB)" aggregate="total"><expression>[SQL2].[Source Used GB]/1024</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Source Type]='SnapMirror'</filterExpression></detailFilter></detailFilters></query><query name="Orphaned by Capacity Range">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL19" type="passThrough">
			<sqlText>SELECT 		CASE 	
		WHEN 	x.orphanedGB BETWEEN 10 AND 50
		THEN 	'10-50GB'
		WHEN 	x.orphanedGB BETWEEN 50 AND 100
		THEN 	'50-100GB'
		WHEN 	x.orphanedGB BETWEEN 100 AND 250
		THEN 	'100-250GB'
		WHEN 	x.orphanedGB BETWEEN 250 AND 500
		THEN 	'250-500GB'
		ELSE 	'500+ GB'
	END 	AS 'Capacity Range',
	CASE 	WHEN 	x.orphanedGB BETWEEN 10 AND 50
		THEN 	0
		WHEN 	x.orphanedGB BETWEEN 50 AND 100
		THEN 	1
		WHEN 	x.orphanedGB BETWEEN 100 AND 250
		THEN 	2
		WHEN 	x.orphanedGB BETWEEN 250 AND 500
		THEN 	3
		ELSE 	4
	END 	capacityRange,
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 
	) X
GROUP BY
	capacityRange</sqlText>
		<mdProjectedItems><mdProjectedItem name="Capacity Range"/><mdProjectedItem name="capacityRange"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Capacity Range"><expression>[SQL19].[Capacity Range]</expression></dataItem><dataItem name="capacityRange"><expression>[SQL19].[capacityRange]</expression></dataItem><dataItem aggregate="total" name="Volume Count"><expression>[SQL19].[Volume Count]</expression></dataItem></selection>
		</query><query name="Total Orphaned by Capacity Range">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		CASE 	
		WHEN 	x.orphanedGB BETWEEN 10 AND 50
		THEN 	'10-50GB'
		WHEN 	x.orphanedGB BETWEEN 50 AND 100
		THEN 	'50-100GB'
		WHEN 	x.orphanedGB BETWEEN 100 AND 250
		THEN 	'100-250GB'
		WHEN 	x.orphanedGB BETWEEN 250 AND 500
		THEN 	'250-500GB'
		ELSE 	'500+ GB'
	END 	AS 'Capacity Range',
	CASE 	WHEN 	x.orphanedGB BETWEEN 10 AND 50
		THEN 	0
		WHEN 	x.orphanedGB BETWEEN 50 AND 100
		THEN 	1
		WHEN 	x.orphanedGB BETWEEN 100 AND 250
		THEN 	2
		WHEN 	x.orphanedGB BETWEEN 250 AND 500
		THEN 	3
		ELSE 	4
	END 	capacityRange,
	ROUND(SUM(x.orphanedGB),2) as 'Provisioned (GB)'

FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 
	) X
GROUP BY
	capacityRange</sqlText>
		<mdProjectedItems><mdProjectedItem name="Capacity Range"/><mdProjectedItem name="capacityRange"/><mdProjectedItem name="Provisioned (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Capacity Range"><expression>[SQL8].[Capacity Range]</expression></dataItem><dataItem name="capacityRange"><expression>[SQL8].[capacityRange]</expression></dataItem><dataItem name="Provisioned (GB)" aggregate="total"><expression>[SQL8].[Provisioned (GB)]</expression></dataItem></selection>
		</query><query name="Provisioned Capacity">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Not Orphaned' 
	END as 'Type',
	ROUND(SUM(x.orphanedGB)/1024,2) as 'Provisioned (TB)',
	ROUND(SUM(x.usedMB)/1024/1024,2) as 'Used (TB)',
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	-- AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'None' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	-- AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &gt;= 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &gt; 5	

) X
GROUP BY Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL7].[Type]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL7].[Provisioned (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL7].[Used (TB)]</expression></dataItem><dataItem name="Volume Count"><expression>[SQL7].[Volume Count]</expression></dataItem></selection>
		</query><query name="Orphaned Count">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Not Orphaned' 
	END as 'Type',
	
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'None' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &gt;= 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &gt; 5	

) X
GROUP BY Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL3].[Type]</expression></dataItem><dataItem name="Volume Count" aggregate="total"><expression>[SQL3].[Volume Count]</expression></dataItem></selection>
		</query><query name="Orphaned Capacity">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Not Orphaned' 
	END as 'Type',
	ROUND(SUM(x.orphanedGB)/1024,2) as 'Provisioned (TB)',
	ROUND(SUM(x.usedMB)/1024/1024,2) as 'Used (TB)',
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'None' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &gt;= 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &gt; 5	

) X
GROUP BY Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL4].[Type]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL4].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Count" aggregate="total"><expression>[SQL4].[Volume Count]</expression></dataItem><dataItem name="Orphaned (TB)" aggregate="total"><expression>IF([Type]='Orphaned') THEN ([Provisioned (TB)]) ELSE (0)</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL4].[Used (TB)]</expression></dataItem></selection>
		</query><query name="Orphaned DR Capacity">
			<source>
				
			<sqlQuery name="SQL13" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   ROUND(SUM(x.orphanedGB)/1024,2) as 'Provisioned (TB)',
	ROUND(SUM(x.usedMB)/1024/1024,2) as 'Used (TB)',
	COUNT(x.volumeId) AS 'Volume Count'

FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.snapShotAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.snapShotUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica
		WHERE dwh_inventory.dr_internal_volume_replica.technology='SnapMirror' )
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 


) X
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL13].[Provisioned (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL13].[Used (TB)]</expression></dataItem><dataItem name="Volume Count"><expression>[SQL13].[Volume Count]</expression></dataItem></selection>
		</query><query name="Orphaned vs Orphaned DR">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Orphaned DR' 
	END as 'Type',
	
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'DR' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.snapShotAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.snapShotUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica
		WHERE dwh_inventory.dr_internal_volume_replica.technology='SnapMirror')
	-- AND    	dwh_inventory.internal_volume.snapshotUsedCapacityMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5	

) X
GROUP BY Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL5].[Type]</expression></dataItem><dataItem name="Volume Count" aggregate="total"><expression>[SQL5].[Volume Count]</expression></dataItem></selection>
		</query><query name="Orphaned vs Orphaned DR Capacity">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Orphaned DR' 
	END as 'Type',
	
	ROUND(SUM(orphanedGB)/1024,2) as 'Provisioned (TB)'

FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'DR' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.snapShotAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.snapShotUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica
		WHERE dwh_inventory.dr_internal_volume_replica.technology='SnapMirror')
	-- AND    	dwh_inventory.internal_volume.snapshotUsedCapacityMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5	

) X
GROUP BY Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Provisioned (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL6].[Type]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL6].[Provisioned (TB)]</expression></dataItem></selection>
		</query><query name="Top 5 Clusters by Orphaned Count">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Not Orphaned' 
	END as 'Type',
	X.Storage as 'Cluster',
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'None' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &gt;= 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &gt; 5	

) X
GROUP BY Cluster, Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Cluster"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL9].[Type]</expression></dataItem><dataItem name="Cluster"><expression>[SQL9].[Cluster]</expression></dataItem><dataItem name="Volume Count" aggregate="total"><expression>[SQL9].[Volume Count]</expression></dataItem><dataItem name="rank"><expression>rank([Volume Count])</expression></dataItem></selection>
		<detailFilters><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter><detailFilter><filterExpression>[Type]='Orphaned'</filterExpression></detailFilter></detailFilters></query><query name="Top 5 Clusters by Orphaned Capacity">
			<source>
				
			<sqlQuery name="SQL10" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Not Orphaned' 
	END as 'Type',
	ROUND(SUM(x.orphanedGB),2) as 'Provisioned (GB)',
	x.Storage as 'Cluster',
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'None' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &gt;= 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &gt; 5	

) X
GROUP BY Cluster, Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Cluster"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL10].[Type]</expression></dataItem><dataItem name="Provisioned (GB)" aggregate="total"><expression>[SQL10].[Provisioned (GB)]</expression></dataItem><dataItem name="Cluster"><expression>[SQL10].[Cluster]</expression></dataItem><dataItem name="Volume Count"><expression>[SQL10].[Volume Count]</expression></dataItem><dataItem name="rank"><expression>rank([Provisioned (GB)])</expression></dataItem></selection>
		<detailFilters><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter><detailFilter><filterExpression>[Type]='Orphaned'</filterExpression></detailFilter></detailFilters></query><query name="Orphaned Count by DC">
			<source>
				
			<sqlQuery name="SQL11" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Not Orphaned' 
	END as 'Type',
	x.datacenter as 'DataCenter',
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_dimension.datacenter as datacenter,
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_dimension.datacenter as datacenter,
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'None' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &gt;= 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &gt; 5	

) X
GROUP BY DataCenter, Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="DataCenter"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL11].[Type]</expression></dataItem><dataItem name="DataCenter"><expression>[SQL11].[DataCenter]</expression></dataItem><dataItem name="Volume Count" aggregate="total"><expression>[SQL11].[Volume Count]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Type]='Orphaned'</filterExpression></detailFilter></detailFilters></query><query name="Orphanced Capacity by DC">
			<source>
				
			<sqlQuery name="SQL12" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 		
                   CASE
	WHEN x.orphanedType='Performance' THEN 'Orphaned'
	ELSE 'Not Orphaned' 
	END as 'Type',
	x.datacenter as 'DataCenter',
	ROUND(SUM(x.orphanedGB)/1024,2) as 'Provisioned (TB)',
	COUNT(x.volumeId) AS 'Volume Count'
FROM 	(
	SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_dimension.datacenter AS datacenter,
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'Performance' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &lt; 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &lt;= 5 

UNION

SELECT 	dwh_performance.tier_dimension.name AS tierName,
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_dimension.datacenter AS datacenter,
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.internal_volume.name AS 'Volume',
		dwh_inventory.internal_volume.id AS volumeId,
		'None' AS orphanedType,
		ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) AS orphanedGB,
		ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB,2) AS usedMB,
		ROUND(MAX(dwh_performance.internal_volume_daily_performance_fact.totalIopsMax),0) AS accessed
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 90 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	AND 	dwh_performance.storage_dimension.manufacturer = 'NetApp'
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.internal_volume_dimension
	ON 	dwh_performance.internal_volume_daily_performance_fact.internalVolumeTk = dwh_performance.internal_volume_dimension.tk
	JOIN 	dwh_inventory.internal_volume
	ON 	dwh_performance.internal_volume_dimension.id = dwh_inventory.internal_volume.id
	AND 	dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
	AND    	dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB &gt;= 100
	GROUP BY
		dwh_inventory.internal_volume.id
	HAVING
		accessed &gt; 5	

) X
GROUP BY DataCenter, Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="DataCenter"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL12].[Type]</expression></dataItem><dataItem name="DataCenter"><expression>[SQL12].[DataCenter]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL12].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Count"><expression>[SQL12].[Volume Count]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Type]='Orphaned'</filterExpression></detailFilter></detailFilters></query><query name="Large Volumes">
			<source>
				
			<sqlQuery name="SQL14" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
x.type as 'Type',
ROUND(SUM(x.AllocatedGB),2) as 'Allocated (GB)',
ROUND(SUM(x.UsedGB),2) as 'Used (GB)',
COUNT(x.volumeId) AS 'Volume Count'

FROM (
SELECT
'Over-Provisioned' as type,
dwh_inventory.internal_volume.id as volumeid,
dwh_inventory.internal_volume.TotalAllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_inventory.internal_volume.TotalUsedCapacityFromDeviceMB/1024 as 'UsedGB'

FROM dwh_inventory.internal_volume

WHERE dwh_inventory.internal_volume.thinProvisioned=1
AND dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
AND (dwh_inventory.internal_volume.TotalAllocatedCapacityMB/1024) &gt; 100
AND (dwh_inventory.internal_volume.TotalUsedCapacityFromDeviceMB/dwh_inventory.internal_volume.TotalAllocatedCapacityMB) &lt; .25

GROUP BY dwh_inventory.internal_volume.id 

UNION

SELECT
'Large Volume' as type,
dwh_inventory.internal_volume.id as volumeid,
dwh_inventory.internal_volume.TotalAllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_inventory.internal_volume.TotalUsedCapacityFromDeviceMB/1024 as 'UsedGB'

FROM dwh_inventory.internal_volume

WHERE dwh_inventory.internal_volume.thinProvisioned=0 
AND dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)
AND (dwh_inventory.internal_volume.TotalAllocatedCapacityMB/1024) &gt; 100
AND (dwh_inventory.internal_volume.TotalUsedCapacityFromDeviceMB/dwh_inventory.internal_volume.TotalAllocatedCapacityMB) &lt; .25


GROUP BY dwh_inventory.internal_volume.id 

) x

GROUP BY Type</sqlText>
		<mdProjectedItems><mdProjectedItem name="Type"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Volume Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Type"><expression>[SQL14].[Type]</expression></dataItem><dataItem name="Allocated (GB)" aggregate="total"><expression>[SQL14].[Allocated (GB)]</expression></dataItem><dataItem name="Used (GB)"><expression>[SQL14].[Used (GB)]</expression></dataItem><dataItem name="Volume Count" aggregate="total"><expression>[SQL14].[Volume Count]</expression></dataItem></selection>
		</query></queries></report>